BACK-UP DATABASES ON ORIGINAL SERVER

This topic covers how to back up and move the System Galaxy and idProducer databases on the original server.

 

VERIFY MAINTENANCE AGREEMENT IS VALID

 

1. Before you make backups, make sure System Galaxy product Maintenance Agreement is valid (not expired). 

   1. From the System Galaxy menu, go to Configure > Options > Registrations > System.

   2. If the Maintenance Agreement is expired, you must contact authorized customer support to update the maintenance agreement.

   3. Once the Maintenance Agreement is valid, you can proceed.

 

 

STOP ALL CLIENT CONNECTIONS TO ORIGINAL SERVER

 

2. On the original server, close all client connections as follows …

   1. Close all instances of System Galaxy software that is running on any/all client computers.

   2. Close all instances of idProducer software (web clients) that is running on any/all computers.

   3. Quit all idProducer Print Dispatchers on all clients.
      Do this by opening the Task-tray and right-clicking the Print Dispatcher Icon,
      then selecting Quit application from the shortcut menu (shown below).

   4. Stop the idProducer Connector services on all client computers from the Windows® Services screen.

      

         Print Dispatcher Task Menu

 

 

STOP & DISABLE ALL GALAXY SERVICES ON THE ORIGINAL SERVER

 

REQUIREMENTS ...

• On the original server, you must stop and disable the following services ...

GCS WebAPI service GCS ClientGW service GCS Comm service GCS DataLoader service GCS DBWriter service GCS Event service GCS (and any other GCS service) Notate which other services you stopped.

idProducer Connector service * idProducer Server service IIS Service   * Must be stopped on every client workstation.

 

3. Open the Services window by typing “Services” into the Search field of the Windows Taskbar.  

   

    

4. Double-click on the name of the service to open the Properties screen.

1. Click the Stop button in the Properties screen.

2. Select the “Disabled” option from the Start Type droplist.

3. Click the Apply button.

4. Click OK to close the Properties screen. (make sure you do this for all the services listed)

   

    

 

 

 

BACK UP THE DATABASES ON ORIGINAL SERVER

 

1. Open the GCS Service Manger from the System Galaxy folder: c:\GCS\System Galaxy\Utilities

2. Right-click on GCSServiceManager.exe and choose “Run as Administrator” from the menu.

   

   C:\GCS\System Galaxy\Utilities > GCS Service Manager.exe

    

    

    

3. In the GCS Service Manager tool …

   1. Select (highlight) “MSSQL$GCSSQLEXPRESS“ service at the bottom of the list.

   2. Click the [Configure SQL Backup] button, to open the backup screen.

       

      

        GCS Service Manager > MSSQL Service selected.

       

4. In the Configure SQL Server Backup screen, do the following steps …

   1. Assign the desired backup path using the Browse […] button to select the appropriate folder.

      • (GCS Default path) c:\GCS\System Galaxy\Utilities\DBBackup

   2. Enteryour sa login credentials (sa & password)

   3. Select(check) all the database checkboxes (SysGal, SysGalArc and idProducer).

   4. Clickthe [Run/Test Backup] button to generate the backup files.

       

      

      GCS Service Manager > Configure SQL Backup screen

    

5. The “SGBackupResults.txt” should automatically open in Notepad.

   

   Run/Test Backup > SG Backup Results text file

    

6. Windows Explorer auto-opens to the backup folder path that was designated in the Configure SQL Backup screen. 

   RESULTS: The database .bak files and Backup Result files will be shown. 

    

   

   RunTest Backup > Time-stamped Database Backup files

    

7. Move all backup files to an accessible location on the new server.

   • idProducer database

   • SysGal & SysGalArc databases

   • And all system assets

8. Close all screens that were opened by the backup process.

9. This completes the steps to backup files on the original server. Proceed to the next section

    

    

   .